Release 10.1A: OpenEdge Development:
Progress Dynamics Getting Started

Adding more dynamic Combos

There are two more object fields on the Order viewer. The validation triggers for the DynSports database require these values when performing certain operations from the Order viewer. You can now practice what you did in the "Adding a dynamic Combo to your viewer" section by creating dynamic Combos for the Status and Warehouse fields. You might want to read that section to refresh your memory before beginning.

Adding the Status dynamic Combo

To create the Status Combo:

Select DynamicCombo from the Object Palette.
Click on the Status field in the viewer.
Choose the Create New SDF button.
Set the following values on the SmartDataField Maintenance dialog box:

Field	Value
SmartDataField	StatusCombo
Description	Status dynamic combo
Product module	ds-Entity
Specify base query string	FOR EACH gem_status NO-LOCK INDEXED-REPOSITION
Display seq. of gem_status.status_code	1
Display seq. of gem_status.status_name	2
Key field	gem_status.status_obj
Field label	Status
Tooltip	Select status from list

Choose Save and exit the SmartDataField Maintenance dialog box.

Adding the Warehouse dynamic Combo

To create the Warehouse Combo:

Select DynamicCombo from the Object Palette.
Click on the Warehouse field in the viewer.
Choose the Create New SDF button.
Set the following values on the SmartDataField Maintenance dialog box:

Field	Value
SmartDataField	WarehouseCombo
Description	Warehouse dynamic combo
Product module	ds-Entity
Specify base query string	FOR EACH ivm_warehouse NO-LOCK INDEXED-REPOSITION
Display seq. of ivm_warehouse.warehouse_code	1
Display seq. of ivm_warehouse.warehouse_name	2
Key field	ivm_warehouse.warehouse_obj
Field label	Warehouse
Tooltip	Select warehouse from list

Choose Save and exit the SmartDataField Maintenance dialog box.
Make any final adjustments in the design window to the viewer layout, then choose Save in the AppBuilder toolbar. Your finished viewer should look something like this:



Close the viewer design window.